USE [QMIS]
GO
INSERT INTO [QMIS].[dbo].[mo_clsd]
SELECT * FROM 
OPENDATASOURCE('SQLOLEDB','DATA SOURCE=10.4.41.16\MSSQLSERVER2008;USER ID=SA;PASSWORD=lenovo,2008').
[QMIS].[dbo].[mo_clsd]
GO
INSERT INTO [QMIS].[dbo].[mo_clsd_hist]
SELECT * FROM 
OPENDATASOURCE('SQLOLEDB','DATA SOURCE=10.4.41.16\MSSQLSERVER2008;USER ID=SA;PASSWORD=lenovo,2008').
[QMIS].[dbo].[mo_clsd_hist]
GO
INSERT INTO [QMIS].[dbo].[mo_clsd_tmp]
SELECT * FROM 
OPENDATASOURCE('SQLOLEDB','DATA SOURCE=10.4.41.16\MSSQLSERVER2008;USER ID=SA;PASSWORD=lenovo,2008').
[QMIS].[dbo].[mo_clsd_tmp]
GO